{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "blessed-celebrity",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "extra-shooting",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 读取数据\n",
    "movie = pd.read_csv('data/movie.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "collectible-hierarchy",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Rank</th>\n",
       "      <th>Title</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Description</th>\n",
       "      <th>Director</th>\n",
       "      <th>Actors</th>\n",
       "      <th>Year</th>\n",
       "      <th>Runtime (Minutes)</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Votes</th>\n",
       "      <th>Revenue (Millions)</th>\n",
       "      <th>Metascore</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Guardians of the Galaxy</td>\n",
       "      <td>Action,Adventure,Sci-Fi</td>\n",
       "      <td>A group of intergalactic criminals are forced ...</td>\n",
       "      <td>James Gunn</td>\n",
       "      <td>Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...</td>\n",
       "      <td>2014</td>\n",
       "      <td>121</td>\n",
       "      <td>8.1</td>\n",
       "      <td>757074</td>\n",
       "      <td>333.13</td>\n",
       "      <td>76.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Prometheus</td>\n",
       "      <td>Adventure,Mystery,Sci-Fi</td>\n",
       "      <td>Following clues to the origin of mankind, a te...</td>\n",
       "      <td>Ridley Scott</td>\n",
       "      <td>Noomi Rapace, Logan Marshall-Green, Michael Fa...</td>\n",
       "      <td>2012</td>\n",
       "      <td>124</td>\n",
       "      <td>7.0</td>\n",
       "      <td>485820</td>\n",
       "      <td>126.46</td>\n",
       "      <td>65.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Split</td>\n",
       "      <td>Horror,Thriller</td>\n",
       "      <td>Three girls are kidnapped by a man with a diag...</td>\n",
       "      <td>M. Night Shyamalan</td>\n",
       "      <td>James McAvoy, Anya Taylor-Joy, Haley Lu Richar...</td>\n",
       "      <td>2016</td>\n",
       "      <td>117</td>\n",
       "      <td>7.3</td>\n",
       "      <td>157606</td>\n",
       "      <td>138.12</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Sing</td>\n",
       "      <td>Animation,Comedy,Family</td>\n",
       "      <td>In a city of humanoid animals, a hustling thea...</td>\n",
       "      <td>Christophe Lourdelet</td>\n",
       "      <td>Matthew McConaughey,Reese Witherspoon, Seth Ma...</td>\n",
       "      <td>2016</td>\n",
       "      <td>108</td>\n",
       "      <td>7.2</td>\n",
       "      <td>60545</td>\n",
       "      <td>270.32</td>\n",
       "      <td>59.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Suicide Squad</td>\n",
       "      <td>Action,Adventure,Fantasy</td>\n",
       "      <td>A secret government agency recruits some of th...</td>\n",
       "      <td>David Ayer</td>\n",
       "      <td>Will Smith, Jared Leto, Margot Robbie, Viola D...</td>\n",
       "      <td>2016</td>\n",
       "      <td>123</td>\n",
       "      <td>6.2</td>\n",
       "      <td>393727</td>\n",
       "      <td>325.02</td>\n",
       "      <td>40.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Rank                    Title                     Genre  \\\n",
       "0     1  Guardians of the Galaxy   Action,Adventure,Sci-Fi   \n",
       "1     2               Prometheus  Adventure,Mystery,Sci-Fi   \n",
       "2     3                    Split           Horror,Thriller   \n",
       "3     4                     Sing   Animation,Comedy,Family   \n",
       "4     5            Suicide Squad  Action,Adventure,Fantasy   \n",
       "\n",
       "                                         Description              Director  \\\n",
       "0  A group of intergalactic criminals are forced ...            James Gunn   \n",
       "1  Following clues to the origin of mankind, a te...          Ridley Scott   \n",
       "2  Three girls are kidnapped by a man with a diag...    M. Night Shyamalan   \n",
       "3  In a city of humanoid animals, a hustling thea...  Christophe Lourdelet   \n",
       "4  A secret government agency recruits some of th...            David Ayer   \n",
       "\n",
       "                                              Actors  Year  Runtime (Minutes)  \\\n",
       "0  Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...  2014                121   \n",
       "1  Noomi Rapace, Logan Marshall-Green, Michael Fa...  2012                124   \n",
       "2  James McAvoy, Anya Taylor-Joy, Haley Lu Richar...  2016                117   \n",
       "3  Matthew McConaughey,Reese Witherspoon, Seth Ma...  2016                108   \n",
       "4  Will Smith, Jared Leto, Margot Robbie, Viola D...  2016                123   \n",
       "\n",
       "   Rating   Votes  Revenue (Millions)  Metascore  \n",
       "0     8.1  757074              333.13       76.0  \n",
       "1     7.0  485820              126.46       65.0  \n",
       "2     7.3  157606              138.12       62.0  \n",
       "3     7.2   60545              270.32       59.0  \n",
       "4     6.2  393727              325.02       40.0  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "educated-screen",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 判断是否为null\n",
    "np.any(pd.isnull(movie))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "charitable-wedding",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 取均值\n",
    "movie['Revenue (Millions)'].fillna(movie['Revenue (Millions)'].mean(), inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "commercial-leisure",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Rank</th>\n",
       "      <th>Title</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Description</th>\n",
       "      <th>Director</th>\n",
       "      <th>Actors</th>\n",
       "      <th>Year</th>\n",
       "      <th>Runtime (Minutes)</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Votes</th>\n",
       "      <th>Revenue (Millions)</th>\n",
       "      <th>Metascore</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Guardians of the Galaxy</td>\n",
       "      <td>Action,Adventure,Sci-Fi</td>\n",
       "      <td>A group of intergalactic criminals are forced ...</td>\n",
       "      <td>James Gunn</td>\n",
       "      <td>Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...</td>\n",
       "      <td>2014</td>\n",
       "      <td>121</td>\n",
       "      <td>8.1</td>\n",
       "      <td>757074</td>\n",
       "      <td>333.13</td>\n",
       "      <td>76.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Prometheus</td>\n",
       "      <td>Adventure,Mystery,Sci-Fi</td>\n",
       "      <td>Following clues to the origin of mankind, a te...</td>\n",
       "      <td>Ridley Scott</td>\n",
       "      <td>Noomi Rapace, Logan Marshall-Green, Michael Fa...</td>\n",
       "      <td>2012</td>\n",
       "      <td>124</td>\n",
       "      <td>7.0</td>\n",
       "      <td>485820</td>\n",
       "      <td>126.46</td>\n",
       "      <td>65.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Split</td>\n",
       "      <td>Horror,Thriller</td>\n",
       "      <td>Three girls are kidnapped by a man with a diag...</td>\n",
       "      <td>M. Night Shyamalan</td>\n",
       "      <td>James McAvoy, Anya Taylor-Joy, Haley Lu Richar...</td>\n",
       "      <td>2016</td>\n",
       "      <td>117</td>\n",
       "      <td>7.3</td>\n",
       "      <td>157606</td>\n",
       "      <td>138.12</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Sing</td>\n",
       "      <td>Animation,Comedy,Family</td>\n",
       "      <td>In a city of humanoid animals, a hustling thea...</td>\n",
       "      <td>Christophe Lourdelet</td>\n",
       "      <td>Matthew McConaughey,Reese Witherspoon, Seth Ma...</td>\n",
       "      <td>2016</td>\n",
       "      <td>108</td>\n",
       "      <td>7.2</td>\n",
       "      <td>60545</td>\n",
       "      <td>270.32</td>\n",
       "      <td>59.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Suicide Squad</td>\n",
       "      <td>Action,Adventure,Fantasy</td>\n",
       "      <td>A secret government agency recruits some of th...</td>\n",
       "      <td>David Ayer</td>\n",
       "      <td>Will Smith, Jared Leto, Margot Robbie, Viola D...</td>\n",
       "      <td>2016</td>\n",
       "      <td>123</td>\n",
       "      <td>6.2</td>\n",
       "      <td>393727</td>\n",
       "      <td>325.02</td>\n",
       "      <td>40.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Rank                    Title                     Genre  \\\n",
       "0     1  Guardians of the Galaxy   Action,Adventure,Sci-Fi   \n",
       "1     2               Prometheus  Adventure,Mystery,Sci-Fi   \n",
       "2     3                    Split           Horror,Thriller   \n",
       "3     4                     Sing   Animation,Comedy,Family   \n",
       "4     5            Suicide Squad  Action,Adventure,Fantasy   \n",
       "\n",
       "                                         Description              Director  \\\n",
       "0  A group of intergalactic criminals are forced ...            James Gunn   \n",
       "1  Following clues to the origin of mankind, a te...          Ridley Scott   \n",
       "2  Three girls are kidnapped by a man with a diag...    M. Night Shyamalan   \n",
       "3  In a city of humanoid animals, a hustling thea...  Christophe Lourdelet   \n",
       "4  A secret government agency recruits some of th...            David Ayer   \n",
       "\n",
       "                                              Actors  Year  Runtime (Minutes)  \\\n",
       "0  Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...  2014                121   \n",
       "1  Noomi Rapace, Logan Marshall-Green, Michael Fa...  2012                124   \n",
       "2  James McAvoy, Anya Taylor-Joy, Haley Lu Richar...  2016                117   \n",
       "3  Matthew McConaughey,Reese Witherspoon, Seth Ma...  2016                108   \n",
       "4  Will Smith, Jared Leto, Margot Robbie, Viola D...  2016                123   \n",
       "\n",
       "   Rating   Votes  Revenue (Millions)  Metascore  \n",
       "0     8.1  757074              333.13       76.0  \n",
       "1     7.0  485820              126.46       65.0  \n",
       "2     7.3  157606              138.12       62.0  \n",
       "3     7.2   60545              270.32       59.0  \n",
       "4     6.2  393727              325.02       40.0  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "spiritual-manitoba",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 替换所有缺失值\n",
    "for i in movie.columns:\n",
    "    if np.any(pd.isnull(movie[i])):\n",
    "        movie[i].fillna(movie[i].mean(), inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "destroyed-skirt",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np.any(pd.isnull(movie))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "horizontal-patient",
   "metadata": {},
   "source": [
    "# 题2：获取电影评分平均分和导演人数"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "paperback-fundamentals",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Rank</th>\n",
       "      <th>Title</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Description</th>\n",
       "      <th>Director</th>\n",
       "      <th>Actors</th>\n",
       "      <th>Year</th>\n",
       "      <th>Runtime (Minutes)</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Votes</th>\n",
       "      <th>Revenue (Millions)</th>\n",
       "      <th>Metascore</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Guardians of the Galaxy</td>\n",
       "      <td>Action,Adventure,Sci-Fi</td>\n",
       "      <td>A group of intergalactic criminals are forced ...</td>\n",
       "      <td>James Gunn</td>\n",
       "      <td>Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...</td>\n",
       "      <td>2014</td>\n",
       "      <td>121</td>\n",
       "      <td>8.1</td>\n",
       "      <td>757074</td>\n",
       "      <td>333.13</td>\n",
       "      <td>76.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Prometheus</td>\n",
       "      <td>Adventure,Mystery,Sci-Fi</td>\n",
       "      <td>Following clues to the origin of mankind, a te...</td>\n",
       "      <td>Ridley Scott</td>\n",
       "      <td>Noomi Rapace, Logan Marshall-Green, Michael Fa...</td>\n",
       "      <td>2012</td>\n",
       "      <td>124</td>\n",
       "      <td>7.0</td>\n",
       "      <td>485820</td>\n",
       "      <td>126.46</td>\n",
       "      <td>65.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Split</td>\n",
       "      <td>Horror,Thriller</td>\n",
       "      <td>Three girls are kidnapped by a man with a diag...</td>\n",
       "      <td>M. Night Shyamalan</td>\n",
       "      <td>James McAvoy, Anya Taylor-Joy, Haley Lu Richar...</td>\n",
       "      <td>2016</td>\n",
       "      <td>117</td>\n",
       "      <td>7.3</td>\n",
       "      <td>157606</td>\n",
       "      <td>138.12</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Sing</td>\n",
       "      <td>Animation,Comedy,Family</td>\n",
       "      <td>In a city of humanoid animals, a hustling thea...</td>\n",
       "      <td>Christophe Lourdelet</td>\n",
       "      <td>Matthew McConaughey,Reese Witherspoon, Seth Ma...</td>\n",
       "      <td>2016</td>\n",
       "      <td>108</td>\n",
       "      <td>7.2</td>\n",
       "      <td>60545</td>\n",
       "      <td>270.32</td>\n",
       "      <td>59.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Suicide Squad</td>\n",
       "      <td>Action,Adventure,Fantasy</td>\n",
       "      <td>A secret government agency recruits some of th...</td>\n",
       "      <td>David Ayer</td>\n",
       "      <td>Will Smith, Jared Leto, Margot Robbie, Viola D...</td>\n",
       "      <td>2016</td>\n",
       "      <td>123</td>\n",
       "      <td>6.2</td>\n",
       "      <td>393727</td>\n",
       "      <td>325.02</td>\n",
       "      <td>40.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Rank                    Title                     Genre  \\\n",
       "0     1  Guardians of the Galaxy   Action,Adventure,Sci-Fi   \n",
       "1     2               Prometheus  Adventure,Mystery,Sci-Fi   \n",
       "2     3                    Split           Horror,Thriller   \n",
       "3     4                     Sing   Animation,Comedy,Family   \n",
       "4     5            Suicide Squad  Action,Adventure,Fantasy   \n",
       "\n",
       "                                         Description              Director  \\\n",
       "0  A group of intergalactic criminals are forced ...            James Gunn   \n",
       "1  Following clues to the origin of mankind, a te...          Ridley Scott   \n",
       "2  Three girls are kidnapped by a man with a diag...    M. Night Shyamalan   \n",
       "3  In a city of humanoid animals, a hustling thea...  Christophe Lourdelet   \n",
       "4  A secret government agency recruits some of th...            David Ayer   \n",
       "\n",
       "                                              Actors  Year  Runtime (Minutes)  \\\n",
       "0  Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...  2014                121   \n",
       "1  Noomi Rapace, Logan Marshall-Green, Michael Fa...  2012                124   \n",
       "2  James McAvoy, Anya Taylor-Joy, Haley Lu Richar...  2016                117   \n",
       "3  Matthew McConaughey,Reese Witherspoon, Seth Ma...  2016                108   \n",
       "4  Will Smith, Jared Leto, Margot Robbie, Viola D...  2016                123   \n",
       "\n",
       "   Rating   Votes  Revenue (Millions)  Metascore  \n",
       "0     8.1  757074              333.13       76.0  \n",
       "1     7.0  485820              126.46       65.0  \n",
       "2     7.3  157606              138.12       62.0  \n",
       "3     7.2   60545              270.32       59.0  \n",
       "4     6.2  393727              325.02       40.0  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "ecological-quilt",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "6.723199999999999"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 获取电影平均分\n",
    "movie[\"Rating\"].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "exceptional-stage",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "644"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 获取导演人数\n",
    "np.unique(movie[\"Director\"]).shape[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "efficient-musical",
   "metadata": {},
   "source": [
    "# 题3：绘制Rating，Runtime (Minutes)的关系图"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "retained-vocabulary",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:ylabel='Frequency'>"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAABJIAAAHSCAYAAAC3jeHUAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAAbsElEQVR4nO3dfdCld13f8c+XLC0EUcAsaUyCi06KxqohLkiLWpWiPChBO6UwFRmGMXQaO1CdqYFhhP7BDM4oWDuVMTzUoDwYedDUpJaQMlr/kLgJKeQBSgpBEgJZ1BoQBkz89o/72noTk93v3nD2nJO8XjP33Nf5nXPd93dnrsls3ns9VHcHAAAAAI7lAeseAAAAAIDtICQBAAAAMCIkAQAAADAiJAEAAAAwIiQBAAAAMCIkAQAAADCyb90DfCVOOeWUPnDgwLrHAAAAALjPuPrqqz/T3fvv6b2tDkkHDhzIoUOH1j0GAAAAwH1GVX383t5zaRsAAAAAI0ISAAAAACNCEgAAAAAjQhIAAAAAI0ISAAAAACNCEgAAAAAjQhIAAAAAI0ISAAAAACNCEgAAAAAjQhIAAAAAI0ISAAAAACNCEgAAAAAjQhIAAAAAI0ISAAAAACNCEgAAAAAjQhIAAAAAI0ISAAAAACNCEgAAAAAjQhIAAAAAI/vWPQAAAKzLgQsvW/cI3M3Nr3r6ukcA4CickQQAAADAiJAEAAAAwIhL2wAAgI3hcsPN5JJD4AhnJAEAAAAwIiQBAAAAMCIkAQAAADAiJAEAAAAwIiQBAAAAMCIkAQAAADAiJAEAAAAwIiQBAAAAMCIkAQAAADAiJAEAAAAwIiQBAAAAMCIkAQAAADAiJAEAAAAwIiQBAAAAMCIkAQAAADAiJAEAAAAwIiQBAAAAMCIkAQAAADAiJAEAAAAwIiQBAAAAMCIkAQAAADAiJAEAAAAwIiQBAAAAMCIkAQAAADAiJAEAAAAwIiQBAAAAMCIkAQAAADAiJAEAAAAwIiQBAAAAMCIkAQAAADAiJAEAAAAwIiQBAAAAMCIkAQAAADAiJAEAAAAwIiQBAAAAMCIkAQAAADAiJAEAAAAwIiQBAAAAMCIkAQAAADAiJAEAAAAwsrKQVFVnVtV7q+qGqrq+ql60rL+iqm6tqmuXr6ft2uclVXVTVX24qn54VbMBAAAAcPz2rfBn35nkZ7v7mqp6aJKrq+qK5b3XdPcv7v5wVZ2d5NlJvi3JNyR5T1X9w+6+a4UzAgAAADC0sjOSuvu27r5m2f5skhuTnH6UXc5L8rbu/mJ3fyzJTUkev6r5AAAAADg+J+QeSVV1IMljk7xvWfrpqvpAVb2xqh6+rJ2e5BO7drslRw9PAAAAAJxAKw9JVfU1Sd6R5MXdfUeS1yb55iTnJLktyS8d5887v6oOVdWhw4cPf7XHBQAAAOBerDQkVdUDsxOR3tzd70yS7v50d9/V3X+T5HX528vXbk1y5q7dz1jWvkx3X9TdB7v74P79+1c5PgAAAAC7rPKpbZXkDUlu7O5X71o/bdfHfizJdcv2pUmeXVV/v6oeneSsJFetaj4AAAAAjs8qn9r2xCTPTfLBqrp2WXtpkudU1TlJOsnNSV6YJN19fVVdkuSG7Dzx7QJPbAMAAADYHCsLSd39R0nqHt66/Cj7vDLJK1c1EwAAAAB7d0Ke2gYAAADA9hOSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGFlZSKqqM6vqvVV1Q1VdX1UvWtYfUVVXVNVHlu8PX9arqn6lqm6qqg9U1bmrmg0AAACA47fKM5LuTPKz3X12kickuaCqzk5yYZIru/usJFcur5PkqUnOWr7OT/LaFc4GAAAAwHFaWUjq7tu6+5pl+7NJbkxyepLzkly8fOziJM9cts9L8qbe8cdJHlZVp61qPgAAAACOzwm5R1JVHUjy2CTvS3Jqd9+2vPWpJKcu26cn+cSu3W5Z1gAAAADYACsPSVX1NUnekeTF3X3H7ve6u5P0cf6886vqUFUdOnz48FdxUgAAAACOZqUhqaoemJ2I9Obufuey/Okjl6wt329f1m9Ncuau3c9Y1r5Md1/U3Qe7++D+/ftXNzwAAAAAX2aVT22rJG9IcmN3v3rXW5cmed6y/bwkv7tr/SeXp7c9Iclf7roEDgAAAIA127fCn/3EJM9N8sGqunZZe2mSVyW5pKpekOTjSZ61vHd5kqcluSnJ55M8f4WzAQAAAHCcVhaSuvuPktS9vP2ke/h8J7lgVfMAAAAA8JU5IU9tAwAAAGD7CUkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIzsW/cAAAAAbLYDF1627hG4m5tf9fR1j8D9lDOSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBGSAAAAABgRkgAAAAAYEZIAAAAAGBmFpKr69lUPAgAAAMBmm56R9KtVdVVV/Zuq+rqVTgQAAADARhqFpO7+3iT/KsmZSa6uqrdU1ZNXOhkAAAAAG2V8j6Tu/kiSlyX5uST/NMmvVNWHqurHVzUcAAAAAJtjeo+k76iq1yS5MckPJvnR7v7WZfs1K5wPAAAAgA2xb/i5/5Tk9Ule2t1fOLLY3Z+sqpetZDIAAAAANso0JD09yRe6+64kqaoHJHlQd3++u39jZdMBAAAAsDGm90h6T5IH73p98rIGAAAAwP3ENCQ9qLs/d+TFsn3yakYCAAAAYBNNQ9JfVdW5R15U1Xcl+cJRPg8AAADAfcz0HkkvTvLbVfXJJJXkHyT5l6saCgAAAIDNMwpJ3f0nVfUtSR6zLH24u/96dWMBAAAAsGmmZyQlyeOSHFj2Obeq0t1vWslUAAAAAGycUUiqqt9I8s1Jrk1y17LcSYQkAAAAgPuJ6RlJB5Oc3d29ymEAAAAA2FzTp7Zdl50bbAMAAABwPzU9I+mUJDdU1VVJvnhksbufsZKpAADuYw5ceNm6RwAA+IpNQ9IrVjkEAAAAAJtvFJK6+w+q6huTnNXd76mqk5OctNrRAAAAANgko3skVdVPJXl7kl9blk5P8jvH2OeNVXV7VV23a+0VVXVrVV27fD1t13svqaqbqurDVfXDx/0nAQAAAGClpjfbviDJE5PckSTd/ZEkjzzGPr+e5Cn3sP6a7j5n+bo8Sarq7CTPTvJtyz6/WlXOeAIAAADYINOQ9MXu/tKRF1W1L0kfbYfu/sMkfz78+ecleVt3f7G7P5bkpiSPH+4LAAAAwAkwDUl/UFUvTfLgqnpykt9O8l/3+Dt/uqo+sFz69vBl7fQkn9j1mVuWtb+jqs6vqkNVdejw4cN7HAEAAACA4zUNSRcmOZzkg0lemOTyJC/bw+97bZJvTnJOktuS/NLx/oDuvqi7D3b3wf379+9hBAAAAAD2YvrUtr9J8rrla8+6+9NHtqvqdUl+b3l5a5Izd330jGUNAAAAgA0xCklV9bHcwz2RuvubjueXVdVp3X3b8vLHkhx5otulSd5SVa9O8g1Jzkpy1fH8bAAAAABWaxSSkhzctf2gJP8iySOOtkNVvTXJ9yc5papuSfLyJN9fVedkJ0rdnJ3L5NLd11fVJUluSHJnkgu6+67xnwIAAACAlZte2vZnd1v65aq6OsnPH2Wf59zD8huO8vlXJnnlZB4AAAAATrzppW3n7nr5gOycoTQ9mwkAAACA+4BpDNr9dLU7s3NZ2rO+6tMAAAAAsLGml7b9wKoHAQAAAGCzTS9t+5mjvd/dr/7qjAMAAADApjqep7Y9Lsmly+sfTXJVko+sYigAAAAANs80JJ2R5Nzu/mySVNUrklzW3T+xqsEAAAAA2CwPGH7u1CRf2vX6S8saAAAAAPcT0zOS3pTkqqp61/L6mUkuXslEAAAAAGyk6VPbXllV/y3J9y5Lz+/u969uLAAAAAA2zfTStiQ5Ockd3f0fk9xSVY9e0UwAAAAAbKBRSKqqlyf5uSQvWZYemOQ3VzUUAAAAAJtnekbSjyV5RpK/SpLu/mSSh65qKAAAAAA2zzQkfam7O0knSVU9ZHUjAQAAALCJpiHpkqr6tSQPq6qfSvKeJK9b3VgAAAAAbJpjPrWtqirJbyX5liR3JHlMkp/v7itWPBsAAAAAG+SYIam7u6ou7+5vTyIeAQAAANxPTS9tu6aqHrfSSQAAAADYaMc8I2nx3Ul+oqpuzs6T2yo7Jyt9x6oGAwAAAGCzHDUkVdWjuvtPk/zwCZoHAAAAgA11rDOSfifJud398ap6R3f/8xMwEwAAAAAb6Fj3SKpd29+0ykEAAAAA2GzHCkl9L9sAAAAA3M8c69K276yqO7JzZtKDl+3kb2+2/bUrnQ4AAACAjXHUkNTdJ52oQQAAAADYbMe6tA0AAAAAkghJAAAAAAwJSQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjKwsJFXVG6vq9qq6btfaI6rqiqr6yPL94ct6VdWvVNVNVfWBqjp3VXMBAAAAsDerPCPp15M85W5rFya5srvPSnLl8jpJnprkrOXr/CSvXeFcAAAAAOzBykJSd/9hkj+/2/J5SS5eti9O8sxd62/qHX+c5GFVddqqZgMAAADg+J3oeySd2t23LdufSnLqsn16kk/s+twty9rfUVXnV9Whqjp0+PDh1U0KAAAAwJdZ2822u7uT9B72u6i7D3b3wf37969gMgAAAADuyYkOSZ8+csna8v32Zf3WJGfu+twZyxoAAAAAG+JEh6RLkzxv2X5ekt/dtf6Ty9PbnpDkL3ddAgcAAADABti3qh9cVW9N8v1JTqmqW5K8PMmrklxSVS9I8vEkz1o+fnmSpyW5Kcnnkzx/VXMBAAAAsDcrC0nd/Zx7eetJ9/DZTnLBqmYBAAAA4Cu3tpttAwAAALBdhCQAAAAARoQkAAAAAEaEJAAAAABGhCQAAAAARoQkAAAAAEaEJAAAAABGhCQAAAAARoQkAAAAAEaEJAAAAABGhCQAAAAARoQkAAAAAEaEJAAAAABGhCQAAAAARoQkAAAAAEaEJAAAAABGhCQAAAAARoQkAAAAAEaEJAAAAABGhCQAAAAARoQkAAAAAEaEJAAAAABGhCQAAAAARoQkAAAAAEaEJAAAAABGhCQAAAAARoQkAAAAAEaEJAAAAABGhCQAAAAARoQkAAAAAEaEJAAAAABGhCQAAAAARoQkAAAAAEaEJAAAAABGhCQAAAAARoQkAAAAAEaEJAAAAABGhCQAAAAARoQkAAAAAEaEJAAAAABGhCQAAAAARoQkAAAAAEaEJAAAAABGhCQAAAAARoQkAAAAAEaEJAAAAABGhCQAAAAARoQkAAAAAEaEJAAAAABGhCQAAAAARoQkAAAAAEaEJAAAAABGhCQAAAAARoQkAAAAAEaEJAAAAABGhCQAAAAARoQkAAAAAEaEJAAAAABGhCQAAAAARoQkAAAAAEb2rXsAAOCr78CFl617BAAA7oOckQQAAADAiJAEAAAAwIiQBAAAAMDIWu6RVFU3J/lskruS3NndB6vqEUl+K8mBJDcneVZ3/8U65gMAAADg71rnGUk/0N3ndPfB5fWFSa7s7rOSXLm8BgAAAGBDbNKlbecluXjZvjjJM9c3CgAAAAB3t66Q1EneXVVXV9X5y9qp3X3bsv2pJKeuZzQAAAAA7sla7pGU5Hu6+9aqemSSK6rqQ7vf7O6uqr6nHZfwdH6SPOpRj1r9pAAAAAAkWdMZSd196/L99iTvSvL4JJ+uqtOSZPl++73se1F3H+zug/v37z9RIwMAAADc753wkFRVD6mqhx7ZTvJDSa5LcmmS5y0fe16S3z3RswEAAABw79ZxadupSd5VVUd+/1u6+/er6k+SXFJVL0jy8STPWsNsAAAAANyLEx6SuvujSb7zHtb/LMmTTvQ8AAAAAMys66ltAAAAAGwZIQkAAACAESEJAAAAgBEhCQAAAIARIQkAAACAESEJAAAAgBEhCQAAAIARIQkAAACAESEJAAAAgBEhCQAAAIARIQkAAACAESEJAAAAgBEhCQAAAIARIQkAAACAESEJAAAAgBEhCQAAAIARIQkAAACAESEJAAAAgBEhCQAAAIARIQkAAACAESEJAAAAgBEhCQAAAIARIQkAAACAESEJAAAAgBEhCQAAAIARIQkAAACAESEJAAAAgBEhCQAAAIARIQkAAACAESEJAAAAgBEhCQAAAIARIQkAAACAESEJAAAAgBEhCQAAAICRfeseAAAAADg+By68bN0jcDc3v+rp6x7hhHBGEgAAAAAjQhIAAAAAI0ISAAAAACNCEgAAAAAjbrYNwFfEjR4BAOD+wxlJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIwISQAAAACMCEkAAAAAjAhJAAAAAIzsW/cAAMfjwIWXrXsEAACA+y1nJAEAAAAwIiQBAAAAMCIkAQAAADAiJAEAAAAwIiQBAAAAMCIkAQAAADCyb90DwKbymHkAAAD4cht3RlJVPaWqPlxVN1XVheueBwAAAIAdGxWSquqkJP85yVOTnJ3kOVV19nqnAgAAACDZvEvbHp/kpu7+aJJU1duSnJfkhrVOdQK4jAoAAADYdBt1RlKS05N8YtfrW5Y1AAAAANZs085IOqaqOj/J+cvLz1XVh9c5zwY4Jcln1j0EW8mxw145dtgrxw575dhhrxw77JVjh+NWv3CfOm6+8d7e2LSQdGuSM3e9PmNZ+/+6+6IkF53IoTZZVR3q7oPrnoPt49hhrxw77JVjh71y7LBXjh32yrHDXtxfjptNu7TtT5KcVVWPrqq/l+TZSS5d80wAAAAAZMPOSOruO6vqp5P89yQnJXljd1+/5rEAAAAAyIaFpCTp7suTXL7uObaIy/zYK8cOe+XYYa8cO+yVY4e9cuywV44d9uJ+cdxUd697BgAAAAC2wKbdIwkAAACADSUkbamqOrOq3ltVN1TV9VX1onXPxHaoqgdV1VVV9b+WY+c/rHsmtkdVnVRV76+q31v3LGyXqrq5qj5YVddW1aF1z8N2qKqHVdXbq+pDVXVjVf3jdc/E5quqxyz/rTnydUdVvXjdc7EdqurfLX9Hvq6q3lpVD1r3TGyHqnrRctxcf1//b45L27ZUVZ2W5LTuvqaqHprk6iTP7O4b1jwaG66qKslDuvtzVfXAJH+U5EXd/cdrHo0tUFU/k+Rgkq/t7h9Z9zxsj6q6OcnB7v7Mumdhe1TVxUn+Z3e/fnmi78nd/X/XPBZbpKpOSnJrku/u7o+vex42W1Wdnp2/G5/d3V+oqkuSXN7dv77eydh0VfWPkrwtyeOTfCnJ7yf5191901oHWxFnJG2p7r6tu69Ztj+b5MYkp693KrZB7/jc8vKBy5eizDFV1RlJnp7k9eueBbjvq6qvS/J9Sd6QJN39JRGJPXhSkv8jInEc9iV5cFXtS3Jykk+ueR62w7cmeV93f76770zyB0l+fM0zrYyQdB9QVQeSPDbJ+9Y8CltiuTzp2iS3J7miux07TPxykn+f5G/WPAfbqZO8u6qurqrz1z0MW+HRSQ4n+S/LJbWvr6qHrHsots6zk7x13UOwHbr71iS/mORPk9yW5C+7+93rnYotcV2S762qr6+qk5M8LcmZa55pZYSkLVdVX5PkHUle3N13rHsetkN339Xd5yQ5I8njl1Mx4V5V1Y8kub27r173LGyt7+nuc5M8NckFVfV96x6IjbcvyblJXtvdj03yV0kuXO9IbJPlcshnJPntdc/Cdqiqhyc5Lzsh+xuSPKSqfmK9U7ENuvvGJL+Q5N3Zuazt2iR3rXOmVRKStthyf5t3JHlzd79z3fOwfZZLBN6b5ClrHoXN98Qkz1juc/O2JD9YVb+53pHYJsu/8qa7b0/yruzcQwCO5pYkt+w6a/bt2QlLMPXUJNd096fXPQhb458l+Vh3H+7uv07yziT/ZM0zsSW6+w3d/V3d/X1J/iLJ/173TKsiJG2p5YbJb0hyY3e/et3zsD2qan9VPWzZfnCSJyf50FqHYuN190u6+4zuPpCdywT+R3f7FzpGquohy4Mhslya9EPZOQUc7lV3fyrJJ6rqMcvSk5J4qAjH4zlxWRvH50+TPKGqTl7+f+tJ2bkXLRxTVT1y+f6o7Nwf6S3rnWh19q17APbsiUmem+SDy71ukuSl3X35+kZiS5yW5OLlKSYPSHJJd3uUO7BKpyZ5187fybMvyVu6+/fXOxJb4t8mefNyidJHkzx/zfOwJZZo/eQkL1z3LGyP7n5fVb09yTVJ7kzy/iQXrXcqtsg7qurrk/x1kgvuyw+IqG4PawIAAADg2FzaBgAAAMCIkAQAAADAiJAEAAAAwIiQBAAAAMCIkAQAAADAiJAEAAAAwIiQBAAAAMCIkAQAAADAyP8DQKauUjOWS5wAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 1440x576 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "movie[\"Rating\"].plot(kind='hist',figsize=(20,8))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "reverse-indicator",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "anticipated-senior",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.9"
  },
  "nbTranslate": {
   "displayLangs": [
    "*"
   ],
   "hotkey": "alt-t",
   "langInMainMenu": true,
   "sourceLang": "en",
   "targetLang": "fr",
   "useGoogleTranslate": true
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
